Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
A worksheet’s row-and-column structure can be used to organize and store a
____.
a. | table | c. | function | b. | formula | d. | cell |
|
|
|
2.
|
As a database in Excel, each row of a worksheet can store a record, and each
column can store a(n) ____.
a. | record | c. | field | b. | entity | d. | element |
|
|
|
3.
|
Even though Excel is not a true ____ management system, it can be used as a ____
tool.
a. | formula | c. | calculation | b. | spreadsheet | d. | database |
|
|
|
4.
|
Excel automatically creates an empty row in the table so that you are ready to
enter the first ____ in the table.
a. | formula | c. | record | b. | field | d. | cell |
|
|
|
5.
|
No visible changes appear on the worksheet when the table contains no records.
As records are entered into the table, the assigned formats apply, even as more ____ are added to the
table.
a. | rows | c. | data | b. | columns | d. | functions |
|
|
|
6.
|
Excel has built-in data ____ features to ensure that the data entered into a
cell or range of cells is within limits.
a. | calculation | c. | validation | b. | guideline | d. | maximization |
|
|
|
7.
|
Pressing the ____ key adds the next row below the table to the table.
|
|
|
8.
|
The HLOOKUP function is used when the table direction is ____.
a. | top to bottom | c. | horizontal | b. | bottom to top | d. | vertical |
|
|
|
9.
|
Why is the VLOOKUP function used more often than other lookup functions?
a. | because it has more powerful calculations | c. | because it is easier to
implement | b. | because most tables are vertical | d. | because it is the default lookup
function |
|
|
|
10.
|
The general form of the VLOOKUP function is ____.
a. | =VLOOKUP(table_array, col_index_num) | b. | =VLOOKUP(lookup_value,
row_index_num) | c. | =VLOOKUP(lookup_value, table_array, col_index_num) | d. | =VLOOKUP(lookup_value) |
|
|
|
11.
|
A table_array contains table ____.
a. | text | c. | functions | b. | arguments | d. | dollar signs |
|
|
|
12.
|
Conditional formatting allows you to create ____ that change the formatting of a
cell or range of cells based on the value of a cell.
a. | rules | c. | comments | b. | data | d. | objects |
|
|
|
13.
|
The field or fields selected for sorting records are called ____ keys.
a. | records | c. | field | b. | record | d. | sort |
|
|
|
14.
|
Displaying ____ is a tool for summarizing data in a table.
a. | automatic subtotals | c. | sum total | b. | auto summarize | d. | automatic sum |
|
True/False
Indicate whether the
statement is true or false.
|
|
|
15.
|
Banded columns provide alternating colors every other column.
|
|
|
16.
|
Data can be sorted by using the Sort button on the Data tab on the
Ribbon.
|
|
|
17.
|
If you make a mistake in a sort operation, you can return the records to their
original order by clicking the Undo button on the Quick Access Toolbar.
|
|
|
18.
|
The most common subtotal used with the Subtotals command is the SUM function,
which causes Excel to display a sum each time the control field changes.
|
Matching
|
|
|
Identify the letter of the choice that best matches the phrase or
definition. a. | SUMIF | f. | Customer Filter | b. | COUNTIF | g. | Auto Filter | c. | DCOUNT | h. | query | d. | extract
range | i. | sort
keys | e. | criteria range | j. | conditional formatting |
|
|
|
19.
|
Allows you to enter custom criteria, such as multiple options or ranges of
numbers.
|
|
|
20.
|
Uses specific criteria to add a range of values.
|
|
|
21.
|
Uses specific criteria to count a number of items.
|
|
|
22.
|
The location where Excel copies the records that meet the comparison criteria
in the criteria range to another part of the worksheet.
|
|
|
23.
|
The process of filtering activity based on one or more filter criteria.
|
|
|
24.
|
Process of creating rules that change the formatting of a cell or range of
cells based on the value of a cell.
|
|
|
25.
|
Counts the number of numeric entries in a table field that pass a test.
|